AdEnroll 
Logical Entity Name  AdEnroll 
Default Table Name  AdEnroll 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

AdEnroll Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SyStudentID(FK)    int  NO 
 
StuNum    char(10)  NO 
 
AppRecDate    datetime  YES 
 
EnrollDate    datetime  YES 
 
StartDate    datetime  YES 
 
ExpStartDate    datetime  YES 
 
ReEntryDate    datetime  YES 
 
GradDate    datetime  YES 
 
MidDate    datetime  YES 
 
FaExitDate    datetime  YES 
 
LDA    datetime  YES 
 
StatusDate    datetime  YES 
 
AmRepID    int  NO 
 
SyCampusID    int  NO 
 
SySchoolStatusID(FK)    int  NO 
 
AdGradeLevelID    int  NO 
 
GPA    numeric(11, 6)  NO 
 
CoreGPA    numeric(11, 6)  YES 
 
NumAvg    numeric(11, 6)  NO 
 
CoreNumAvg    numeric(11, 6)  YES 
 
MinutesAttended    money  YES 
 
HoursAttempt    numeric(9, 2)  NO 
 
HoursEarned    numeric(9, 2)  NO 
 
CreditsAttempt    money  NO 
 
CreditsEarned    money  NO 
 
CoreCreditsAttempt    money  YES 
 
CoreCreditsEarned    money  YES 
 
HoursReq    money  NO 
 
CreditsReq    money  NO 
 
HoursSched    money  NO 
 
CreditsSched    money  NO 
 
MinutesAbsent    int  YES 
 
MinutesMakeUp    int  YES 
 
DaysAbsent    money  NO 
 
adTermID    int  YES 
 
adAttStatID    int  NO 
 
adShiftID    int  NO 
 
adProgramDescrip    varchar(120)  YES 
 
adProgramVersionID(FK)    int  NO 
 
TransferInDate    datetime  YES 
 
DegreeAudit    char(6)  NO 
 
SAP    char(1)  NO 
 
SaBillingMethodID    int  YES 
 
DateBilled    datetime  YES 
 
ARBalance    money  NO 
 
adGradeScaleID    int  NO 
 
DropEarn    money  NO 
 
Comment    varchar(255)  NO 
 
ModFlag    char(1)  NO 
 
TranscriptIssue    datetime  YES 
 
Userid    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
ts    timestamp  NO 
 
AdEnrollID(PK)    int  NO 
 
AdAdvisorID    int  YES 
 
AdReasonID    int  YES 
 
CumGPAPoints    money  YES 
 
GPACredits    money  YES 
 
ExternBeginDate    datetime  YES 
 
QTExport    bit  YES 
 
AdSapStatusID    int  YES 
 
DropDate    datetime  YES 
 
FaEntrDate    datetime  YES 
 
Transfer    bit  NO 
 
PrevGradDate    datetime  YES 
 
RightsResponsibilitiesAck    bit  NO 
 
DropType    char(1)  YES 
 
IPEDSState(FK)    char(2)  NO 
 
ExpectedRefundProcessDate    datetime  YES 
 
AttendanceArchived    bit  NO 
 
OrigGradDate    datetime  YES 
 
AdProgramID(FK)    int  YES 
 
AdStartDateID(FK)    int  YES 
 
LastActivityDate    datetime  YES 
 
AmZoneID    int  YES 
 
AmApplicantTypeID(FK)    int  YES 
 
OriginalAmRepID    int  YES 
 
Applicant    bit  NO 
 
ApplicantProgress    int  NO 
 
AdCatalogYearID(FK)    int  YES 
 
OriginalExpStartDate    datetime  YES 
 
IPEDSTransfer    bit  NO 
 
ExpectedCreditsPerTerm    numeric(7, 2)  NO 
 
ExpectedHoursPerWeekForExternship    numeric(9, 2)  NO 
 
SAPCheckpoint    tinyint  NO 
 
RecalculateTermSequence    bit  NO 
 
LinkedSAPEnrollId(FK)    int  YES 
 
NSLDSWithdrawalDate    datetime  YES 
 
ReEntry    tinyint  NO 
 
CrmSuppressFlag    bit  NO 
 
TransferCredits    money  YES 
 
StatChangeType    int  NO 
 
amPrevEducID    int  NO 
 
ReentryAfter180    datetime  YES 
 
SPEProgression    money  YES 
 
IsUIUpdate    bit  NO 
 
AOSTransferDate    datetime  YES 
 
OutsideCourseWorkHours    numeric(9, 2)  NO 
 
FaCredits    numeric(9, 2)  NO 
 
AutoChargesTermID    int  YES 
 
FAAttStatID    int  NO 
 
NoOfCategoriesMFApplied    int  NO 
 

AdEnroll Primary and Unique Keys 
Key Name  Key Type  Keys 
AdEnroll_IDS_Shf_AttSt_Stu_Grd_SchSt_Rp_PrgVr_BlMth_Rs_SAP_Ctl_U_N_IDX  Index  SyCampusID, adShiftID, adAttStatID, SyStudentID, AdGradeLevelID, SySchoolStatusID, AmRepID, adProgramVersionID, SaBillingMethodID, AdReasonID, AdSapStatusID, AdCatalogYearID, AdEnrollID 
AdEnroll_SyStudentId_SyCampusId_AdProgramVersionId_AdEnrollId_U_N_IDX  Index  SyStudentID, SyCampusID, adProgramVersionID, AdEnrollID 
AdEnroll_adProVerID_SyCamID_SaBilMetId_SySchStaId_CreReq_HouReq_AdShiId_DatBil_ExpStaDat_GraDat_AdEnrID_U_N_IDX  Index  adProgramVersionID, SyCampusID, SaBillingMethodID, SySchoolStatusID, CreditsReq, HoursReq, adShiftID, DateBilled, ExpStartDate, GradDate, AdEnrollID 
AdEnroll_AdPrgrmVrsnId_SyCmpsID_SySchlSttsId_AdnrllId_SyStdntId_StrtDt_GrdDt_Stnm_U_N_IDX  Index  adProgramVersionID, SyCampusID, SySchoolStatusID, AdEnrollID, SyStudentID, StartDate, GradDate, StuNum 
AdEnroll_AdEnrollID_U_C_IDX  PrimaryKey  AdEnrollID 
AdEnroll_SyCampusID_SaBillingMethodID_AdEnrollID_U_IDX  Index  SyCampusID, SaBillingMethodID, AdEnrollID 
Uk_AdEnrollLinkedSAPEnrollID_AdEnrollAdEnrollID  Index  LinkedSAPEnrollId, AdEnrollID 

AdEnroll Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
AdCatalogYear  Non-Identifying  Zero or One to Zero or More  FK_AdEnroll_AdCatalogYearID_AdCatalogYear_AdCatalogYearID      AdCatalogYearID  NO  YES 
AdProgram  Non-Identifying  Zero or One to Zero or More  FK_AdEnroll_AdProgramID_AdProgram_AdProgramID      AdProgramID  NO  YES 
AdProgramVersion  Non-Identifying  One To Zero or More  FK_AdEnroll_adProgramVersionID_AdProgramVersion_AdProgramVersionID      adProgramVersionID  NO  YES 
AdStartDate  Non-Identifying  Zero or One to Zero or More  FK_AdEnroll_AdStartDateID_AdStartDate_AdStartDateID      AdStartDateID  NO  YES 
AmApplicantType  Non-Identifying  Zero or One to Zero or More  FK_AdEnroll_AmApplicantTypeID_AmApplicantType_AmApplicantTypeID      AmApplicantTypeID  NO  YES 
syState  Non-Identifying  One To Zero or More  FK_AdEnroll_IPEDSState_syState_code      IPEDSState  NO  YES 
AdEnroll  Non-Identifying  Zero or One to Zero or More  FK_AdEnroll_LinkedAdEnrollId_AdEnrollId      LinkedSAPEnrollId  NO  YES 
SySchoolStatus  Non-Identifying  One To Zero or More  FK_AdEnroll_SySchoolStatusID_SySchoolStatus_SySchoolStatusID      SySchoolStatusID  NO  YES 
syStudent  Non-Identifying  One To Zero or More  FK_AdEnroll_SyStudentID_syStudent_SyStudentID      SyStudentID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
AdEnrollTermConfirm  Non-Identifying  One To Zero or More  AdEnrollTermConfirm_AdEnrollId_AdEnroll_AdEnrollId        NO  YES 
AdApplicationExternalMap  Non-Identifying  One To Zero or More  FK_AdApplicationExternalMap_AdEnrollId_AdEnrollAdEnrollID        NO  YES 
AdConcentrationByEnrollment  Non-Identifying  One To Zero or More  FK_AdConcentrationByEnrollment_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AdDegreeAuditUnmatchedTakenCourse  Non-Identifying  One To Zero or More  FK_AdDegreeAuditUnmatchedTakenCourseAdEnrollId_AdEnrollAdEnrollId        NO  YES 
AdEnroll  Non-Identifying  One To Zero or More  FK_AdEnroll_LinkedAdEnrollId_AdEnrollId        NO  YES 
AdEnrollBook  Non-Identifying  One To Zero or More  FK_AdEnrollBook_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AdEnrollDegreeAuditCourse  Non-Identifying  One To Zero or More  FK_AdEnrollDegreeAuditCourse_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AdEnrollDegreeAuditCourseCategory  Non-Identifying  One To Zero or More  FK_AdEnrollDegreeAuditCourseCategory_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AdEnrollDegreeAuditFulfillment  Non-Identifying  One To Zero or More  FK_AdEnrollDegreeAuditFulfillment_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AdEnrollDegreeAuditRequirementRule  Non-Identifying  One To Zero or More  FK_AdEnrollDegreeAuditRequirementRule_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AdEnrollExternalMap  Non-Identifying  One To Zero or More  FK_AdEnrollExternalMap_AdEnrollId_AdEnroll_AdEnrollId        NO  YES 
AdEnrollExternalMap  Non-Identifying  One To Zero or More  FK_adEnrollExternalMapadEnrollId_adEnrolladEnrollId        NO  YES 
AdEnrollHonors  Non-Identifying  One To Zero or More  FK_AdEnrollHonors.AdEnrollID_AdEnroll.AdEnrollID        NO  YES 
AdEnrollNonTermBreakInfo  Non-Identifying  One To Zero or More  FK_AdEnrollNonTermBreakInfoAdEnrollID_AdEnrollAdEnrollID        NO  YES 
AdEnrollRegistration  Identifying  One To Zero or More  FK_AdEnrollRegistration_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AdEnrollRegistrationGroup  Non-Identifying  One To Zero or More  FK_AdEnrollRegistrationGroup_AdEnrollID_AdEnroll_AdEnroll        NO  YES 
AdEnrollRegTerm  Non-Identifying  One To Zero or More  fk_AdEnrollRegTerm_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AdEnrollSched  Non-Identifying  One To Zero or More  FK_AdEnrollSched_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AdEnrollSchedOtherEnroll  Non-Identifying  One To Zero or More  FK_AdEnrollSchedOtherEnroll_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AdEnrollSchedStatusHistory  Non-Identifying  One To Zero or More  FK_AdEnrollSchedStatusHistory_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AdEnrollTerm  Non-Identifying  One To Zero or More  FK_AdEnrollTerm_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AdEnrollTerm_RebuildRelationshipLog  Non-Identifying  One To Zero or More  FK_AdEnrollTerm_RebuildRelationshipLog_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AdEnrollTermRelationshipException  Non-Identifying  One To Zero or More  FK_AdEnrollTermRelationshipException_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AdFees  Non-Identifying  One To Zero or More  FK_AdFees_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AdSapQueue_Detail  Non-Identifying  One To Zero or More  FK_AdSapQueue_Detail_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AdSapQueue_Detail  Non-Identifying  One To Zero or More  FK_AdSapQueue_Detail_LinkedAdEnrollId_AdEnrollId        NO  YES 
AdSPECourseCategory  Non-Identifying  One To Zero or More  FK_AdSPECourseCategory_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AdStudentDegreePathway  Non-Identifying  One To Zero or More  FK_AdStudentDegreePathway_AdEnrollId_AdEnroll_AdEnrollId        NO  YES 
AdStudentTermSequenceHeader  Non-Identifying  One To Zero or More  FK_AdStudentTermSequenceHeader_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AdStudentTransferHeader  Non-Identifying  One To Zero or More  FK_AdStudentTransferHeader_FromAdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AdStudentTransferHeader  Non-Identifying  One To Zero or More  FK_AdStudentTransferHeader_ToAdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AmCollegeTransferAdvance  Non-Identifying  One To Zero or More  FK_AmCollegeTransferAdvance_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
AmEnrollApplication  Non-Identifying  One To Zero or More  FK_AmEnrollApplication_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
FaCampusVantageWorkStudyPayroll  Non-Identifying  One To Zero or More  FK_FaCampusVantageWorkStudyPayroll_AdEnrollID_AdEnroll_AdEnrollId        NO  YES 
FaIntersessionTermRegistration  Non-Identifying  One To Zero or More  FK_FaIntersessionTermRegistration_AdEnrollId_AdEnroll_AdEnrollId        NO  YES 
FaNSLDSStudent  Non-Identifying  One To Zero or More  FK_FaNSLDSStudent_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
FaStudentAidCashPlanHistory  Non-Identifying  One To Zero or More  FK_FaStudentAidCashPlanHistory_AdEnroll_AdEnrollId        NO  YES 
FaStudentAY  Non-Identifying  One To Zero or More  FK_FaStudentAY_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
FaStudentFundSource  Non-Identifying  One To Zero or More  FK_FaStudentFundSourceAdEnrollId_AdEnrollAdEnrollId        NO  YES 
FaStudentLoanPeriod  Non-Identifying  One To Zero or More  FK_FaStudentLoanPeriod_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
HSStudentLeaseHistory  Non-Identifying  One To Zero or More  FK_HsStudentLeaseHistoryAdEnrollID_AdEnrollAdEnrollID        NO  YES 
PlReasonQuestionAnswer  Non-Identifying  One To Zero or More  FK_PlReasonQuestionAnswer_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
PlReasonQuestionAnswerResponseComment  Non-Identifying  One To Zero or More  FK_PlReasonQuestionAnswerResponseComment_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
RecalculateBudgetQueue  Non-Identifying  One To Zero or More  FK_RecalculateBudgetQueue_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SaAutoBillBatchDetail  Non-Identifying  One To Zero or More  FK_SaAutoBillBatchDetail_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SaBillingStatementBatchDetailCharges  Non-Identifying  One To Zero or More  FK_SaBillingStatementBatchDetailCharges_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SaBillingStatementBatchDetailFA  Non-Identifying  One To Zero or More  FK_SaBillingStatementBatchDetailFA_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SaBillingStatementBatchDetailPayments  Non-Identifying  One To Zero or More  FK_SaBillingStatementBatchDetailPayments_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SaBillingStatementBatchStudent  Non-Identifying  One To Zero or More  FK_SaBillingStatementBatchStudent_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SaBillingStatementBatchSubsidiaryDetail  Non-Identifying  One To Zero or More  FK_SaBillingStatementBatchSubsidiaryDetail_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SaCollectionAccountStatus  Non-Identifying  One To Zero or More  FK_SaCollectionAccountStatus_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SaCollections  Non-Identifying  One To Zero or More  FK_SaCollections_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SaEnrollAcctStatus  Non-Identifying  One To Zero or More  FK_SaEnrollAcctStatus_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SaEnrollRevenueChildTerm  Non-Identifying  One To Zero or More  FK_SaEnrollRevenueChildTerm_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SaPendingChargeCourseAmount  Non-Identifying  One To Zero or More  FK_SaPendingChargeCourseAmount_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SaPendingChargeDetail  Non-Identifying  One To Zero or More  FK_saPendingChargeDetail.AdEnrollID_AdEnroll.AdEnrollID        NO  YES 
SaRegBillQueue_Detail  Non-Identifying  One To Zero or More  FK_SaRegBillQueue_Detail_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SaStatementHistory  Non-Identifying  One To Zero or More  FK_SaStatementHistory_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SaStudentLedgerTermUpdatesArchive  Non-Identifying  One To Zero or More  FK_SaStudentLedgerTermUpdatesArchive_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SaStudSubsidiary  Non-Identifying  One To Zero or More  Fk_SaStudSubsidiary_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SaStudSubsidiaryAdjust  Non-Identifying  One To Zero or More  Fk_SaStudSubsidiaryAdjust_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SaSubsidiaryRefund  Non-Identifying  One To Zero or More  Fk_SaSubsidiaryRefund_AdEnroll_AdEnrollID        NO  YES 
SaTransCourse  Non-Identifying  One To Zero or More  FK_SaTransCourse_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SaTransCourseAmount  Non-Identifying  One To Zero or More  FK_SaTransCourseAmount_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SsStudHousingInfo  Identifying  One To Zero or More  FK_SsStudHousingInfo_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SsStudRoommate  Identifying  One To Zero or More  FK_SsStudRoommate_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SyAdvisorByEnroll  Identifying  One To Zero or More  FK_SyAdvisorByEnroll_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 
SyAudit_AdEnroll  Non-Identifying  One To Zero or More  FK_SyAudit_AdEnroll_RecordID_AdEnroll_AdEnrollID        NO  YES 
SyStudentNI  Non-Identifying  One To Zero or More  FK_SyStudentNI_AdEnrollID_AdEnroll_AdEnrollID        NO  YES 

AdEnroll Check Constraints 
Check Constraint Name  CheckConstraint 
Chk_AdEnroll_GradDate  ([Applicant] = 1 or [Applicant] = 0 and [GradDate] is not null) 

AdEnroll Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group   

AdEnroll Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.StudentEnrollmentPeriod 
NO       
Physical (Microsoft SQL Server)
dbo.AdEnroll 
NO       

AdEnroll Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  Addresses_Affiliations 
Logical  Applicant_Enroll 
Logical  CourseRegistration 
Logical  DegreePathway 
Logical  Documents 
Logical  Grades/Attendance 
Logical  LedgerCard_Billing 
Logical  RefundCalculation 
Logical  Refunds_Stipends 
Logical  Revenue_GL_BankDeposit 
Logical  SEVIS 
Logical  StudentEnrollment 
Logical  StudentJobPlacement 
Logical  StudentPayments_Collections 
Logical  StudentPlacementPreferences 
Logical  SubsidiaryLedger 
Logical  Tasks 
Logical  TestScores 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Academic Records 

AdEnroll Data Movement Rules 
Name  Type  Rule Text/Value